home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload Trio 2
/
Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO
/
dir33
/
dmmeq.zip
/
DMMTXT
< prev
Wrap
Text File
|
1994-10-15
|
4KB
|
102 lines
A FEW NOTES ABOUT DMM
DMM stands for Decision Matrix Method, a simple decision-support
tool implemented in Lotus 1-2-3 and, I hope, usable in other
spreadsheet programs.
BACKGROUND
The Ontario Employment Equity Act came into force in the fall of
1994. Among other things, it requires large employers to adopt
"fair" practices in the hiring and promotion of "targeted groups".
These include women, aboriginals, the handicapped, and visible
minorities.
On government demand, employers will have to show compliance.
When that happens, they can benefit from having documented their
decision process.
For this purpose and others I wrote DMM, a Lotus 1-2-3 (R)
template with a WK3 extension that should also work in Microsoft
Excel (R) and Novell Quattro Pro (R).
DMM uses the public-domain Decision-Matrix Method, an old and
simple but good way to rank candidates by various criteria of
your own making. Here a "candidate" can be a person or a thing,
like a new office site.
Some of your criteria can be more important than others. For
instance, when choosing a junior secretary you may find spelling
critical, typing speed moderately important, and experience only
somewhat important. DMM lets you assign such "weighting factors".
DIRECTIONS FOR USE
In Column A you will find rows for eight criteria, marked A
through H. Over-write them with your own. If you have fewer than
eight, leave the remaining code letters in place. They will do no
harm.
You can enter weighting factors in Column B. Use a 10-point scale,
where 1 = of very little importance, 5 = moderately important, and
10 = critical.
DMM processes your entries in Column C, forcing a total of 100 at
the bottom line.
Enter data for your candidates in Columns D through L. DMM
shows them as CH1 (for Choice One) through CH8. Replace the
column headings with three-character abbreviations like people's
initials. I kept the candidate columns narrow to keep the whole
worksheet on one page.
Rate each candidate by each criterion. DMM instantly computes the
the bottom line, which uses a 100-point scale.
Save your worksheet under a unique name.
BACK TO THE DRAWING BOARD
DMM blindly follows your orders. If its bottom-line scores do not
"look right", you may have left out one or more criteria or given
wrong weights to the existing ones.
In that case, make the necessary changes. In doing so, you can
make any candidate win. The changes you make must pass the
"whom-do-you-think-you-are-kidding" test.
TINKERING
I made this a globally-protected worksheet with unprotected data-
entry cells. Your computer will bleat if you try to write where you
should not.
If you want to change the logic or scope of this worksheet, disable
global protection and tinker at will. If it then works better, call
me. If it does not, don't.
TECHNICAL SUPPORT
Call me at 905-849-4949 for help or to suggest improvements.
AUTHOR
Sander Schimmelpenninck, M.A., is an Oakville, Ontario management
consultant in strategic planning, industrial marketing, and market
research.
His Internet address is sander.schimmelpenninck@canrem.com.
LEGAL
This is copyrighted freeware:
You can freely use it, make copies for your own use, and
give its original version to others.
You cannot sell it, but you can charge the going price for
a diskette.
I do not guarantee that this template will work properly.
This file does not form legal advice.